﻿using System;
using Microsoft.EntityFrameworkCore.Migrations;

namespace Model.Migrations
{
    public partial class OA : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.CreateTable(
                name: "Astates",
                columns: table => new
                {
                    Aid = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    AName = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Astates", x => x.Aid);
                });

            migrationBuilder.CreateTable(
                name: "Department",
                columns: table => new
                {
                    Depar_ID = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Depar_NAME = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Depar_tel = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    reamkers = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Department", x => x.Depar_ID);
                });

            migrationBuilder.CreateTable(
                name: "JStates",
                columns: table => new
                {
                    Jid = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Jname = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_JStates", x => x.Jid);
                });

            migrationBuilder.CreateTable(
                name: "leave_Types",
                columns: table => new
                {
                    Lid = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    TypeName = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_leave_Types", x => x.Lid);
                });

            migrationBuilder.CreateTable(
                name: "Role",
                columns: table => new
                {
                    Role_ID = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Role_Name = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    remarks = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Role", x => x.Role_ID);
                });

            migrationBuilder.CreateTable(
                name: "RStates",
                columns: table => new
                {
                    Sid = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Sname = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_RStates", x => x.Sid);
                });

            migrationBuilder.CreateTable(
                name: "Tstate",
                columns: table => new
                {
                    State_ID = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    State_Name = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Tstate", x => x.State_ID);
                });

            migrationBuilder.CreateTable(
                name: "Dispatchacar",
                columns: table => new
                {
                    DisID = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    staff_NAME = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    ApplicationD = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    DateOf = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Drivingtime = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    ContactNumber = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    StartingPoint = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Endm = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    EstimatedKm = table.Column<int>(type: "int", nullable: false),
                    SeveralPeople = table.Column<int>(type: "int", nullable: false),
                    ChengLi = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Objective = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Travel_leader = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Travel_manager = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Aid = table.Column<int>(type: "int", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Dispatchacar", x => x.DisID);
                    table.ForeignKey(
                        name: "FK_Dispatchacar_Astates_Aid",
                        column: x => x.Aid,
                        principalTable: "Astates",
                        principalColumn: "Aid",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "ExpenseR",
                columns: table => new
                {
                    ExpenseID = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    staff_NAME = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    ApplicationTim = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    department = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    ApplicationFe = table.Column<int>(type: "int", nullable: false),
                    ExpenseType = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    explain = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Travel_leader = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Travel_manager = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Aid = table.Column<int>(type: "int", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_ExpenseR", x => x.ExpenseID);
                    table.ForeignKey(
                        name: "FK_ExpenseR_Astates_Aid",
                        column: x => x.Aid,
                        principalTable: "Astates",
                        principalColumn: "Aid",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "Position",
                columns: table => new
                {
                    Job_ID = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Job_Name = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Depar_ID = table.Column<int>(type: "int", nullable: false),
                    state_ID = table.Column<int>(type: "int", nullable: false),
                    remarks = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    email = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Position", x => x.Job_ID);
                    table.ForeignKey(
                        name: "FK_Position_Department_Depar_ID",
                        column: x => x.Depar_ID,
                        principalTable: "Department",
                        principalColumn: "Depar_ID",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "Jurisdiction",
                columns: table => new
                {
                    Power_ID = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Power_Name = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    route = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Jid = table.Column<int>(type: "int", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Jurisdiction", x => x.Power_ID);
                    table.ForeignKey(
                        name: "FK_Jurisdiction_JStates_Jid",
                        column: x => x.Jid,
                        principalTable: "JStates",
                        principalColumn: "Jid",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "Activities",
                columns: table => new
                {
                    id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Activity_NAME = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    AName = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Depar_ID = table.Column<int>(type: "int", nullable: false),
                    remarks = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    place = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    ACREATE_DATE = table.Column<DateTime>(type: "datetime2", nullable: false),
                    Adate = table.Column<DateTime>(type: "datetime2", nullable: false),
                    funds = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Job_ID = table.Column<int>(type: "int", nullable: false),
                    Aid = table.Column<int>(type: "int", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Activities", x => x.id);
                    table.ForeignKey(
                        name: "FK_Activities_Astates_Aid",
                        column: x => x.Aid,
                        principalTable: "Astates",
                        principalColumn: "Aid",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_Activities_Position_Job_ID",
                        column: x => x.Job_ID,
                        principalTable: "Position",
                        principalColumn: "Job_ID",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "Leaves",
                columns: table => new
                {
                    LeaveID = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Lid = table.Column<int>(type: "int", nullable: false),
                    SName = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Depar_ID = table.Column<int>(type: "int", nullable: false),
                    remarks = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Job_ID = table.Column<int>(type: "int", nullable: false),
                    DateOfApplication = table.Column<DateTime>(type: "datetime2", nullable: false),
                    LeaveTime = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Aid = table.Column<int>(type: "int", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Leaves", x => x.LeaveID);
                    table.ForeignKey(
                        name: "FK_Leaves_Astates_Aid",
                        column: x => x.Aid,
                        principalTable: "Astates",
                        principalColumn: "Aid",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_Leaves_leave_Types_Lid",
                        column: x => x.Lid,
                        principalTable: "leave_Types",
                        principalColumn: "Lid",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_Leaves_Position_Job_ID",
                        column: x => x.Job_ID,
                        principalTable: "Position",
                        principalColumn: "Job_ID",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "Personnel",
                columns: table => new
                {
                    staff_ID = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    staff_NAME = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    staff_CODE = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    staff_alias = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    username = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    password = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    email = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    home_tel = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Address = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    State_ID = table.Column<int>(type: "int", nullable: false),
                    certificates = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    sex = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Entry = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Job_ID = table.Column<int>(type: "int", nullable: false),
                    Role_ID = table.Column<int>(type: "int", nullable: false),
                    remarks = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Personnel", x => x.staff_ID);
                    table.ForeignKey(
                        name: "FK_Personnel_Position_Job_ID",
                        column: x => x.Job_ID,
                        principalTable: "Position",
                        principalColumn: "Job_ID",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_Personnel_Role_Role_ID",
                        column: x => x.Role_ID,
                        principalTable: "Role",
                        principalColumn: "Role_ID",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_Personnel_Tstate_State_ID",
                        column: x => x.State_ID,
                        principalTable: "Tstate",
                        principalColumn: "State_ID",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "Travels",
                columns: table => new
                {
                    id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    travel_name = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    TName = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Depar_ID = table.Column<int>(type: "int", nullable: false),
                    remarks = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    place = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Create_date = table.Column<DateTime>(type: "datetime2", nullable: false),
                    Create_dj = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Job_ID = table.Column<int>(type: "int", nullable: false),
                    Aid = table.Column<int>(type: "int", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Travels", x => x.id);
                    table.ForeignKey(
                        name: "FK_Travels_Astates_Aid",
                        column: x => x.Aid,
                        principalTable: "Astates",
                        principalColumn: "Aid",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_Travels_Position_Job_ID",
                        column: x => x.Job_ID,
                        principalTable: "Position",
                        principalColumn: "Job_ID",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "Works",
                columns: table => new
                {
                    WID = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    WName = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    SName = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Depar_ID = table.Column<int>(type: "int", nullable: false),
                    remarks = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Job_ID = table.Column<int>(type: "int", nullable: false),
                    EstimatedOvertime = table.Column<DateTime>(type: "datetime2", nullable: false),
                    ActualOvertime = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Aid = table.Column<int>(type: "int", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Works", x => x.WID);
                    table.ForeignKey(
                        name: "FK_Works_Astates_Aid",
                        column: x => x.Aid,
                        principalTable: "Astates",
                        principalColumn: "Aid",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_Works_Position_Job_ID",
                        column: x => x.Job_ID,
                        principalTable: "Position",
                        principalColumn: "Job_ID",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "Rights",
                columns: table => new
                {
                    rid = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Role_ID = table.Column<int>(type: "int", nullable: false),
                    Power_ID = table.Column<int>(type: "int", nullable: false),
                    Sid = table.Column<int>(type: "int", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Rights", x => x.rid);
                    table.ForeignKey(
                        name: "FK_Rights_Jurisdiction_Power_ID",
                        column: x => x.Power_ID,
                        principalTable: "Jurisdiction",
                        principalColumn: "Power_ID",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_Rights_Role_Role_ID",
                        column: x => x.Role_ID,
                        principalTable: "Role",
                        principalColumn: "Role_ID",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_Rights_RStates_Sid",
                        column: x => x.Sid,
                        principalTable: "RStates",
                        principalColumn: "Sid",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.InsertData(
                table: "Astates",
                columns: new[] { "Aid", "AName" },
                values: new object[,]
                {
                    { 1, "待审核" },
                    { 2, "已审核" }
                });

            migrationBuilder.InsertData(
                table: "Department",
                columns: new[] { "Depar_ID", "Depar_NAME", "Depar_tel", "reamkers" },
                values: new object[,]
                {
                    { 1, "开发部", "1892737267", "负责公司的项目开发" },
                    { 2, "人事部", "179238397267", "负责公司的人才招聘" }
                });

            migrationBuilder.InsertData(
                table: "JStates",
                columns: new[] { "Jid", "Jname" },
                values: new object[,]
                {
                    { 1, "启用" },
                    { 2, "禁用" }
                });

            migrationBuilder.InsertData(
                table: "RStates",
                columns: new[] { "Sid", "Sname" },
                values: new object[,]
                {
                    { 2, "禁用" },
                    { 1, "启用" }
                });

            migrationBuilder.InsertData(
                table: "Role",
                columns: new[] { "Role_ID", "Role_Name", "remarks" },
                values: new object[,]
                {
                    { 3, "总监", "无" },
                    { 2, "部门经理", "无" },
                    { 1, "总经理", "无" }
                });

            migrationBuilder.InsertData(
                table: "Tstate",
                columns: new[] { "State_ID", "State_Name" },
                values: new object[,]
                {
                    { 2, "离职" },
                    { 1, "在职" }
                });

            migrationBuilder.InsertData(
                table: "leave_Types",
                columns: new[] { "Lid", "TypeName" },
                values: new object[,]
                {
                    { 2, "生病" },
                    { 1, "家里有事" },
                    { 4, "其他" },
                    { 3, "亲戚结婚" }
                });

            migrationBuilder.InsertData(
                table: "Jurisdiction",
                columns: new[] { "Power_ID", "Jid", "Power_Name", "route" },
                values: new object[,]
                {
                    { 1, 1, "人员管理", "/System/Organization" },
                    { 2, 1, "职位管理", "/System/Position" },
                    { 3, 1, "部门管理", "/System/Department" },
                    { 4, 1, "角色管理", "/System/Role" },
                    { 5, 1, "权限管理", "/System/Organization" }
                });

            migrationBuilder.InsertData(
                table: "Position",
                columns: new[] { "Job_ID", "Depar_ID", "Job_Name", "email", "remarks", "state_ID" },
                values: new object[,]
                {
                    { 1, 1, "总经理", "3982343343@qq.com", "无", 1 },
                    { 2, 1, "部门经理", "278317819@qq.com", "无", 1 }
                });

            migrationBuilder.InsertData(
                table: "Personnel",
                columns: new[] { "staff_ID", "Address", "Entry", "Job_ID", "Role_ID", "State_ID", "certificates", "email", "home_tel", "password", "remarks", "sex", "staff_CODE", "staff_NAME", "staff_alias", "username" },
                values: new object[,]
                {
                    { 1, "湖南省长沙市岳麓区", "2020-12-20", 1, 1, 1, "4301209392139381", "315154751@qq.com", "18746729341", "****************", "无", "男", "GH0001", "陈俊华", "无", "chenjunhua" },
                    { 2, "湖南省长沙市芙蓉区", "2020-10-10", 2, 2, 1, "4011203434339381", "66781919@qq.com", "19736729341", "****************", "无", "男", "GH0002", "单松华", "无", "dansohua" }
                });

            migrationBuilder.InsertData(
                table: "Rights",
                columns: new[] { "rid", "Power_ID", "Role_ID", "Sid" },
                values: new object[,]
                {
                    { 1, 1, 1, 1 },
                    { 2, 2, 1, 1 },
                    { 3, 3, 1, 1 },
                    { 4, 4, 1, 1 }
                });

            migrationBuilder.CreateIndex(
                name: "IX_Activities_Aid",
                table: "Activities",
                column: "Aid");

            migrationBuilder.CreateIndex(
                name: "IX_Activities_Job_ID",
                table: "Activities",
                column: "Job_ID");

            migrationBuilder.CreateIndex(
                name: "IX_Dispatchacar_Aid",
                table: "Dispatchacar",
                column: "Aid");

            migrationBuilder.CreateIndex(
                name: "IX_ExpenseR_Aid",
                table: "ExpenseR",
                column: "Aid");

            migrationBuilder.CreateIndex(
                name: "IX_Jurisdiction_Jid",
                table: "Jurisdiction",
                column: "Jid");

            migrationBuilder.CreateIndex(
                name: "IX_Leaves_Aid",
                table: "Leaves",
                column: "Aid");

            migrationBuilder.CreateIndex(
                name: "IX_Leaves_Job_ID",
                table: "Leaves",
                column: "Job_ID");

            migrationBuilder.CreateIndex(
                name: "IX_Leaves_Lid",
                table: "Leaves",
                column: "Lid");

            migrationBuilder.CreateIndex(
                name: "IX_Personnel_Job_ID",
                table: "Personnel",
                column: "Job_ID");

            migrationBuilder.CreateIndex(
                name: "IX_Personnel_Role_ID",
                table: "Personnel",
                column: "Role_ID");

            migrationBuilder.CreateIndex(
                name: "IX_Personnel_State_ID",
                table: "Personnel",
                column: "State_ID");

            migrationBuilder.CreateIndex(
                name: "IX_Position_Depar_ID",
                table: "Position",
                column: "Depar_ID");

            migrationBuilder.CreateIndex(
                name: "IX_Rights_Power_ID",
                table: "Rights",
                column: "Power_ID");

            migrationBuilder.CreateIndex(
                name: "IX_Rights_Role_ID",
                table: "Rights",
                column: "Role_ID");

            migrationBuilder.CreateIndex(
                name: "IX_Rights_Sid",
                table: "Rights",
                column: "Sid");

            migrationBuilder.CreateIndex(
                name: "IX_Travels_Aid",
                table: "Travels",
                column: "Aid");

            migrationBuilder.CreateIndex(
                name: "IX_Travels_Job_ID",
                table: "Travels",
                column: "Job_ID");

            migrationBuilder.CreateIndex(
                name: "IX_Works_Aid",
                table: "Works",
                column: "Aid");

            migrationBuilder.CreateIndex(
                name: "IX_Works_Job_ID",
                table: "Works",
                column: "Job_ID");
        }

        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropTable(
                name: "Activities");

            migrationBuilder.DropTable(
                name: "Dispatchacar");

            migrationBuilder.DropTable(
                name: "ExpenseR");

            migrationBuilder.DropTable(
                name: "Leaves");

            migrationBuilder.DropTable(
                name: "Personnel");

            migrationBuilder.DropTable(
                name: "Rights");

            migrationBuilder.DropTable(
                name: "Travels");

            migrationBuilder.DropTable(
                name: "Works");

            migrationBuilder.DropTable(
                name: "leave_Types");

            migrationBuilder.DropTable(
                name: "Tstate");

            migrationBuilder.DropTable(
                name: "Jurisdiction");

            migrationBuilder.DropTable(
                name: "Role");

            migrationBuilder.DropTable(
                name: "RStates");

            migrationBuilder.DropTable(
                name: "Astates");

            migrationBuilder.DropTable(
                name: "Position");

            migrationBuilder.DropTable(
                name: "JStates");

            migrationBuilder.DropTable(
                name: "Department");
        }
    }
}
